List the assessment methods to be used and the context and resources required for assessment. Copy and paste the relevant sections from the evidence guide below and then re-write these in plain English.
ELEMENT | PERFORMANCE CRITERIA |
Elements describe the essential outcomes. | Performance criteria describe the performance needed to demonstrate achievement of the element. |
1. Identify entities and relationships | 1.1 Analyse business data to understand operations 1.2 Identify boundaries of the system 1.3 Identify entities, attributes, data types and relationships of data 1.4 Review business rules to determine impact 1.5 Document relationships in an entity relationship diagram |
2. Develop normalisation | 2.1 Identify suitable business data 2.2 Undertake normalisation of business data and document results 2.3 Compare normalisation results with entity relationship diagram 2.4 Reconcile differences between data |
3. Validate model | 3.1 Validate data model with client 3.2 Resolve issues or recommendations 3.3 Document completed data model 3.4 Submit to client for final approval |
Evidence of the ability to:
document client business requirements
construct an entity relationship diagram
construct and document a data model
normalise the model
validate the model.
Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.
To complete the unit requirements safely and effectively, the individual must:
fully describe:
database identifiers and their impact on database usability
normalisation rules and processes
type hierarchies, including sub-types, super-types and root-types related to development of structured data types
validation procedures and processes
describe the function and features of:
an approach to data modelling, such as the entity-relationship model
keys, e.g. unique keys, composite keys, primary keys and primary index
time stamps related to the use of keys
user defined types, structured types, reference types and user defined functions
data types and their application
summarise the particular business domain.
Gather evidence to demonstrate consistent performance in conditions that are safe and replicate the workplace. Noise levels, production flow, interruptions and time variances must be typical of those experienced in the systems analysis and design field of work, and include access to:
client’s business requirements
special purpose tools, equipment and materials
industry software packages
computer aided software engineering (CASE) tools
entity relationship diagrams.
Assessors must satisfy NVR/AQTF assessor requirements.